/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package stagingetl;

import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;


/**
 *
 * @author joen
 */
public class DbMSTest {
    private static String dbDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
    private static String connUrl = "jdbc:sqlserver://172.16.101.29;database=arium_staging;user=sa;password=blade";
    
    public static void main(String[] args) throws ClassNotFoundException{
        try {        
            Class.forName(dbDriver);
            Connection conn = DriverManager.getConnection(connUrl);
            String sqlString = "insert into st_stock_recon_n (acno, balance) values ('00001', 0.0)";
            Statement stmt = conn.createStatement();

            stmt.execute(sqlString);

        } catch (SQLException ex) {
            System.out.println(ex.getCause().toString());
        }
    }
}
